﻿CREATE PROCEDURE [dbo].[su_RepoFile_Update]
AS

--if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tu_RepoFile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
--	DROP TABLE tu_RepoFile

TRUNCATE TABLE tu_RepoFile

INSERT INTO tu_RepoFile
SELECT * FROM AFCBANK.DataMining.dbo.All_RepoFiles

--CREATE  CLUSTERED  INDEX [IX_tu_RepoFile_CustID] ON [dbo].[tu_RepoFile]([Cust ID#]) ON [PRIMARY]

